<?php
	require_once(realpath(dirname(__FILE__)) . "/Baseobj.class.php");
	require_once(realpath(dirname(__FILE__)) . "/Declinaisondesc.class.php");
	require_once(realpath(dirname(__FILE__)) . "/Declidisp.class.php");

	class Declinaison extends Baseobj{

		var $id;
		var $classement;

		const TABLE="declinaison";
		var $table=self::TABLE;

		var $bddvars = array("id", "classement");

		function __construct($id = 0){
			parent::__construct();

			if($id > 0)
 			  $this->charger($id);
		}

		function charger($id){
			return $this->getVars("select * from $this->table where id=\"$id\"");
		}

		function changer_classement($id, $type){

			$this->charger($id);
			$remplace = new Declinaison();

			if($type == "M")
				$res = $remplace->getVars("select * from $this->table where classement<" . $this->classement . " order by classement desc limit 0,1");

			else if($type == "D")
				$res  = $remplace->getVars("select * from $this->table where classement>" . $this->classement . " order by classement limit 0,1");

			if(! $res)
				return "";

			$sauv = $remplace->classement;

			$remplace->classement = $this->classement;
			$this->classement = $sauv;

            $remplace->maj();
            $this->maj();

		}

		function isDeclidisp(){
			$declidisp = new Declidisp();
			$query = "select * from $declidisp->table where declinaison=\"" . $this->id . "\"";
			$resul = mysql_query($query);

			return mysql_num_rows($resul);

		}

		function delete($requete){
				$resul = mysql_query($requete);
				CacheBase::getCache()->reset_cache();
		}

		function supprimer(){

            if($this->id == "")
                    return 0;

			$declinaisondesc =  new Declinaisondesc();


			$this->delete("delete from $this->table where id=\"$this->id\"");
			$this->delete("delete from $declinaisondesc->table where declinaison=\"$this->id\"");

			$queryclass = "select * from $this->table order by classement";
			$resclass = mysql_query($queryclass);

			if(mysql_num_rows($resclass) > 0){
				$i = 1;
				while($rowclass = mysql_fetch_object($resclass)){
					$dec = new Declinaison();
					$dec->charger($rowclass->id);
					$dec->classement = $i;
					$dec->maj();
					$i++;
				}
			}


			return 1;

		}

	}

?>